You are here: Evaluating Data > Using the Spreadsheet View > Understanding the Spreadsheet View

Understanding the Spreadsheet View

In this topic
Introduction
Components of the Spreadsheet View
Understanding the Spreadsheet Markers
Functions Within the Spreadsheet
Navigating Within a Spreadsheet
Copying Data
Editing Data
Exporting Data
Printing the Spreadsheet
Saving the Spreadsheet

Introduction

After performing an experiment, the resulting data file can be opened and viewed in three different forms: Experiment view, Spreadsheet view, and Graph view. This topic deals with the Spreadsheet view.

See Also
Touring the TRIOS Workspace.

Components of the Spreadsheet View

Most spreadsheet programs have a recognizable table layout. If you are new to using or setting up a spreadsheet, this topic will provide you with information needed to use the features. See the figure below for some of the components discussed here.

Selected step: Select the step that you wish to display in spreadsheet form from the drop-down list. A data file may contain multiple data steps; only one step displays within a table page at a time. To create another table view within the document to display another step, right-click on the Table tab (located at the bottom of the Table window) and select New Spreadsheet View from the pop-up menu.
Spreadsheet properties: TRIOS has the ability to display the data table and its properties side by side to allow you to see your changes as you make them.
Access this panel by right-clicking and selecting Properties. See Customizing TRIOS Properties for additional information.
When the data displays, each point is contained in a separate cell. The active cell is indicated by a color of your choosing (the default color is Royal blue).

Understanding the Spreadsheet Markers

To comment on or annotate data on the spreadsheet, use spreadsheet markers to indicate items of note associated within a particular data point, cell, row, and/or column. Refer to the table below. See

Adding Markers to a Spreadsheet for additional information.

Spreadsheet Markers
Icon	Description	Location
	Image taken at this point	Row
	This item has been modified.	Cell, Column
	A comment has been added here.	Row, Column
	A bookmark has been added here.	Row
	An invalid point has been marked here.	Row

Functions Within the Spreadsheet

The Spreadsheet view provides a tabular view of the data. The column configuration is based on the step test type. You can perform the following functions in Spreadsheet view:

Display a tabular view of the data for each step in the experiment by selecting from the drop-down list at the top of the window.
Configure the spreadsheet to display the desired variables. See Configuring the Spreadsheet for information.
Choose the spreadsheet properties such as variables, units, fonts, colors, etc. See Customizing TRIOS Properties for information.
Add and view markers. See Adding Markers to a Spreadsheet for information.
View associated images and plots.
Export data.
Edit data.
Print the spreadsheet.

Navigating Within a Spreadsheet

See the table below for details on navigating within a spreadsheet.

Spreadsheet Navigation
Function	Action Needed
Moving up/down within a column	Press the up/down arrow keys on your keyboard.
Moving right within a row	Press the TAB key or right arrow key on your keyboard.
Moving left within a row	Hold down SHIFT and press TAB or press the left arrow key on your keyboard.
Changing column width	Move your cursor over column border until the double-sided arrow is displayed. Click and drag the border to the desired position.
Selecting a row	Position your cursor over the numbered row in the first column and click. The entire row is selected.
Selecting a column	Position your cursor over the desired column and click. The entire column is selected.
Selecting multiple cells	Position your cursor over the first cell, hold down the left mouse button and drag until you have selected the desired contiguous cells. Click in the first cell then hold down the SHIFT key and click in the last desired cell. Hold down the CTRL key while clicking in each desired cell.
Selecting all columns and rows	Position your cursor in the empty cell in the far left corner of the table and click. All columns and rows are selected.
Clearing a column or row	Select multiple cells in a column or row as above. Right click and select Delete from the pop-up menu.

Copying Data

Any range of data can be copied to the clipboard from the spreadsheet and pasted into another application. Follow the instructions in the table below:

Copying Data
Function	Action Needed
Copying an entry	Select the entry. Right-click and select Copy from the pop-up menu.
Copying a column or row	Click in the header above a column to select the column, or click in the numbered column to select the row. Right-click and select Copy from the pop-up menu.
Copying multiple cells	Select multiple cells in a column or row as above. Right-click and select Copy from the pop-up menu.

Editing Data

To edit data, follow the instructions in the table:

NOTE: If another cell is dependent upon the value in the edited cell, it is automatically recalculated. When cells are modified, a modify marker displays. The original data is not altered.

Editing Data
Function	Action Needed
Clearing a column or row	Select multiple cells in a column or row as above. Right-click and select Delete from the pop-up menu.
Editing a cell	Double-click on the entry. Click again to position the cursor. Backspace to delete and type to enter new values.
Adding/configuring columns or rows	See Configuring the Spreadsheet for instructions.
Marking data	See Adding Markers to a Spreadsheet for instructions.

Exporting Data

For information on exporting data, refer to the Exporting Data Help topic.

Printing the Spreadsheet

Print the spreadsheet as follows:

Click the TRIOS button in the upper left corner of the main window. A drop-down menu displays.
Select Print.
Select Print,Print Preview, or Print to PDF (as shown in the list below).

Choose the desired options to complete printing your document.

Saving the Spreadsheet

In addition to the default TRIOS file format, the spreadsheet can be saved in PDF format (.pdf), Universal Analysis format (.ua), or Orchestrator format (.rad). See below for more details.

Saving to a PDF File

Save the spreadsheet as a PDF file as follows:

Click the TRIOS button in the upper-left corner of the main window. A drop-down menu displays.
Select Save As .
Choose PDF Format.
Enter the desired file name and directory location then click Save.

Saving to Alternate File Formats

Save the spreadsheet in .rad (Orchestrator) format or in .ua (Universal Analysis) format as follows:

Click the TRIOS button in the upper-left corner of the main window. A drop-down menu displays.
Select Save As .
Choose Other Formats.
Enter the desired file name and directory location.
From the Save as type drop-down box, choose the file format (.rad or .ua).
Click Save.